package com.central.apps.dao.MaterialInventory;

import org.apache.ibatis.annotations.*;

import java.util.List;
import java.util.Map;
@Mapper
public interface goWarehouseDao {
    @Select("SELECT itemnum,itemdesc,specmodel,unit,quantity,wonum,binnum,lotnum,locations FROM gq_itemapplyline WHERE glnum = #{lldnum}")
    List<Map<String, Object>> getPickingHandler(@Param("lldnum") String lldnum);

    @Insert("INSERT INTO gq_invuseline (invusenum,itemnum,itemdesc,specmodel,unit,quantity,wonum,binnum,lotnum,locations) VALUES (#{map.invusenum},#{map.itemnum},#{map.itemdesc},#{map.specmodel},#{map.unit},#{map.quantity},#{map.wonum},#{map.binnum},#{map.lotnum},#{map.locations})")
    int insert(@Param("map") Map<String, Object> map);

    @Select("SELECT lldnum FROM gq_invuse WHERE id = #{id}")
    String getlldnumById (String id);

    @Delete("delete from gq_invuseline where invusenum = #{invusenum}")
    void delinvuseline (String invusenum);
    @Delete("delete from gq_inquirysheetline where isnum = #{isnum}")
    void delinvuseline2 (String invusenum);

}